A Script Language for Data Integration in Database

نویسنده

  • Qingguo Zheng
چکیده

A Script Language in this paper is designed to transform the original data into the target data by the computing formula. The Script Language can be translated into the corresponding SQL Language, and the computation is finally implemented by the first type of dynamic SQL. The Script Language has the operations of insert, update, delete, union, intersect, and minus for the table in the database. A Script Language is edited by a text file and you can easily modify the computing formula in the text file to deal with the situations when the computing formula have been changed. So you only need modify the text of the script language, but needn’t change the programs that have complied. The format of Script Language { TABLE: table_name COMMAND:command_name Target_item_one=[DISTINCT]Source_item||function(…)[Source_item |function(…)] … == …. Target_item==Source_item|function(…)[Source_item |function(…)] Target_item_n==Source_item| function(…) [ Source_item |function(…)] [FROM:[,]] [WHERE:[,]] [GROUP BY: [,]] [HAVING]:[,]] [ORDER BY:[,]] } [set_operator] { TABLE: table_name COMMAND:command_name Target_item_one==[DISTINCT]Source_item||function(…)[Source_item |function(…)] … == …. Target_item==Source_item|function(…)[Source_item |function(…)] Target_item_n==Source_item| function(…) [ Source_item |function(…)] [FROM:[,]] [WHERE:[,]] [GROUP BY: [,]] [HAVING]:[,]] [ORDER BY:[,]] } set_operator=[UNION,INTERSECT,MINUS] operator=[<+>,<-,><*>,] command_name=[insert,update,delete,truncate,create]

برای دانلود رایگان متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

The Effectiveness of Shadow-Reading With and Without Written Script on Listening Comprehension of Iranian Intermediate EFL Students.

Listening comprehension is at the heart of language learning (Kurita, 2012). It is an importantlanguage skill to develop in terms of second language acquisition (SLA) (Dunkel, 1991; Rost,2001; Vandergrift, 2007).In spite of its importance, L2 learners often regard listening as themost difficult language skill to learn. In this study, shadowing as an act or task in listening, inwhich the learner...

متن کامل

Framework For Consistent Speech Databases

The introduced speech processing framework creates phonetically and prosodically annotated speech databases. It provides with structured data files in eXtensible Markup Language format. Those files include all available information about a recorded utterance inclusively the speech signal. A Document Type Definition (DTD) describes the data structure and provides with the possibilty of automatic...

متن کامل

A Description of the LAMB Web-Derived Language Model Builder

This paper describes the language modeling script constructed for the Spring 2000 Information Retrieval seminar. The script builds on Callan'ss1] work of automatically generating language models for text databases by creating language models for internet search engines. An overview of the work, principles and observed properties of language models, the language modeling script (LAMB) and its sh...

متن کامل

GML Documents: An approach for Database Schema Design and Storing

GML (Geography Markup Language) uses the XML pattern and it possesses mechanisms and conventions to describe geographical information. This paper describes a solution for the storage of GML documents in object-relational database management systems (ORDBMS) supplying the support for the metadata and allowing the integration of the delegated systems and geographical data (in the GML format ) in ...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

عنوان ژورنال:
  • CoRR

دوره cs.DB/0301009  شماره 

صفحات  -

تاریخ انتشار 2003